package com.team2.s3hrjyxm.dao;

import com.team2.s3hrjyxm.pojo.Role;
import org.apache.ibatis.annotations.*;

import java.util.List;
@Mapper
public interface RoleDao {
       @Select("select * from role")
        List<Role> RoleQuery();
       @Insert("insert into role(role_Name,role_Desc,role_Flag) values(#{role_Name},#{role_Desc},#{role_Flag})")
       void roleadd(Role r);
       @Select("select * from role where role_Id=#{value}")
        Role RoleQuerybyid(int role_Id);
       @Delete("delete from role where role_Id=#{value}")
       void roledelete(int role_id);
       @Update("update role set role_Name=#{role_Name},role_Desc=#{role_Desc},role_Flag=#{role_Flag} where role_Id=#{role_Id}")
        int roleupdate(Role role);
}
